﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="hotelinformation.aspx.vb" Inherits="gdrwebapp1.hotelinformation1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">



    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="HotelName" HeaderText="HotelName" 
                SortExpression="HotelName" />
            <asp:BoundField DataField="Stars" HeaderText="Stars" 
                SortExpression="Stars" />
            <asp:BoundField DataField="Hotelurl" HeaderText="Hotelurl" SortExpression="Hotelurl" />
            <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
        </Columns>
    </asp:GridView>

            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" 
        SelectCommand="SELECT [HotelName], [Stars], [Picture], [Hotelurl], [Description] FROM [hotellist] WHERE ([ID] = ?)">
                <SelectParameters>
                    <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
                </SelectParameters>
    </asp:SqlDataSource>


        <br />

        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource2">
        <Columns>
            <asp:BoundField DataField="Author" HeaderText="Author" 
                SortExpression="Author" />
            <asp:BoundField DataField="Comment" HeaderText="Comment" 
                SortExpression="Comment" />
            <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
        </Columns>
    </asp:GridView>

        <br />
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT [Author], [Comment], [Title] FROM [Comments] WHERE ([Hotel_fxid] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="Hotel_fxid" QueryStringField="ID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    <br />
    <p>
       <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3">
        <Columns>
            <asp:BoundField DataField="Chain" HeaderText="Chain" 
                SortExpression="Chain" />
        </Columns>
    </asp:GridView>
</p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString7 %>" ProviderName="<%$ ConnectionStrings:ConnectionString7.ProviderName %>" SelectCommand="SELECT [Chain] FROM [chain] WHERE ([hotellist_fx] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="hotellist_fx" QueryStringField="ID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
</p>
    <p>
        &nbsp;</p>
    <p>
        Add Comments to Comments Table <strong>(Unit 4 Session 2) </strong>
</p>
    <p>
        &nbsp;</p>
    <p>
        Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="fld_author" runat="server"></asp:TextBox>
</p>
<p>Comment&nbsp;
    <asp:TextBox ID="fld_comment" runat="server" Height="192px" TextMode="MultiLine" Width="525px"></asp:TextBox>
&nbsp; 
    <p>Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="fld_title" runat="server"></asp:TextBox>
    <p>&nbsp;<p>
    <asp:Button ID="Button1" runat="server" Text="Add New Comment" Width="372px" />
    <br />


</asp:Content>

